SELECT 'sqlserver' AS dbms_type_name,
       SERVERPROPERTY('ServerName') AS dbms_name,
       CONSTRAINT_CATALOG,
       CONSTRAINT_SCHEMA,
       CONSTRAINT_NAME,
       TABLE_CATALOG,
       TABLE_SCHEMA,
       TABLE_NAME,
       CONSTRAINT_TYPE,
       IS_DEFERRABLE,
       INITIALLY_DEFERRED
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_SCHEMA IS NOT NULL
